home *** CD-ROM | disk | FTP | other *** search
- create table tunsql.continent (
- cont_code integer not null,
- cont_name char(30) not null,
- map_code integer,
- primary key (cont_code)
- );
-
- insert into tunsql.continent values(1000,"Europe",0) ;
- insert into tunsql.continent values(2000,"Africa",0) ;
- insert into tunsql.continent values(3000,"America",0) ;
- insert into tunsql.continent values(4000,"Asia",0) ;
- insert into tunsql.continent values(5000,"Oceania",0) ;
- insert into tunsql.continent values(6000,"Middle-East",0) ;
-
- create table tunsql.map (
- map_code integer not null,
- map_name char(30) not null,
- map_bits byte,
- primary key (map_code)
- );
-
- create table tunsql.country (
- ctry_code integer not null,
- ctry_name char(60) not null,
- cont_code integer not null,
- map_code integer,
- primary key (ctry_code)
- );
-
- /* ---------------------------------------------------------- */
- /* ----------------------- PAYS EUROPE ---------------------- */
- /* ---------------------------------------------------------- */
-
- /* -- CEE -- */
- insert into tunsql.country values(1001,"Germany",1000,0) ;
- insert into tunsql.country values(1002,"Belgium",1000,0) ;
- insert into tunsql.country values(1003,"Danmark",1000,0) ;
- insert into tunsql.country values(1004,"Spain",1000,0) ;
- insert into tunsql.country values(1005,"France",1000,0) ;
- insert into tunsql.country values(1006,"United Kingdom",1000,0) ;
- insert into tunsql.country values(1007,"Greece",1000,0) ;
- insert into tunsql.country values(1008,"Irland",1000,0) ;
- insert into tunsql.country values(1009,"Italy",1000,0) ;
- insert into tunsql.country values(1010,"Luxembourg",1000,0) ;
- insert into tunsql.country values(1011,"Netherland",1000,0) ;
- insert into tunsql.country values(1012,"Portugal",1000,0) ;
-
- /* -- Europe hors URSS -- */
- insert into tunsql.country values(1013,"Albanie",1000,0) ;
- insert into tunsql.country values(1014,"Autriche",1000,0) ;
- insert into tunsql.country values(1015,"Chypre",1000,0) ;
- insert into tunsql.country values(1016,"Finlande",1000,0) ;
- insert into tunsql.country values(1017,"Islande",1000,0) ;
- insert into tunsql.country values(1018,"Norvege",1000,0) ;
- insert into tunsql.country values(1019,"Suede",1000,0) ;
- insert into tunsql.country values(1020,"Suisse",1000,0) ;
- insert into tunsql.country values(1021,"Turquie",1000,0) ;
- insert into tunsql.country values(1022,"Yougoslavie",1000,0) ;
- insert into tunsql.country values(1023,"Bosnie",1000,0) ;
- insert into tunsql.country values(1024,"Croatie",1000,0) ;
- insert into tunsql.country values(1025,"Slovenie",1000,0) ;
-
- /* -- Composant de l"ancienne URSS -- */
- insert into tunsql.country values(1026,"Azerbaidjian",1000,0) ;
- insert into tunsql.country values(1027,"Bielorussie",1000,0) ;
- insert into tunsql.country values(1028,"Bulgarie",1000,0) ;
- insert into tunsql.country values(1029,"Estonie",1000,0) ;
- insert into tunsql.country values(1030,"Georgie",1000,0) ;
- insert into tunsql.country values(1031,"Hongrie",1000,0) ;
- insert into tunsql.country values(1032,"Kazakhstan",1000,0) ;
- insert into tunsql.country values(1033,"Kirguizstan",1000,0) ;
- insert into tunsql.country values(1034,"Lituanie",1000,0) ;
- insert into tunsql.country values(1035,"Moldavie",1000,0) ;
- insert into tunsql.country values(1036,"Mongolie",1000,0) ;
- insert into tunsql.country values(1037,"Ouzbekistan",1000,0) ;
- insert into tunsql.country values(1038,"Pologne",1000,0) ;
- insert into tunsql.country values(1039,"Republique tcheque",1000,0) ;
- insert into tunsql.country values(1040,"Slovaquie",1000,0) ;
- insert into tunsql.country values(1041,"Roumanie",1000,0) ;
- insert into tunsql.country values(1042,"Russie",1000,0) ;
- insert into tunsql.country values(1043,"Tadjikistan",1000,0) ;
- insert into tunsql.country values(1044,"Turkmenistan",1000,0) ;
- insert into tunsql.country values(1045,"Ukraine",1000,0) ;
-
- create table tunsql.statistic (
- ctry_code integer not null,
- stat_year integer not null,
- stat_population decimal(8,2),
- stat_pnb decimal(8,2),
- stat_pnbhab integer,
- stat_pnbhabper decimal(5,2),
- stat_prodind decimal(8,2),
- stat_inflation decimal(5,2),
- stat_tauxchom decimal(4,2),
- stat_soldecom decimal(8,2),
- stat_espvie integer,
- stat_fecondite decimal(5,2),
- stat_tauxscolar decimal(5,2),
- primary key (ctry_code, stat_year)
- );
-
- /* ---------------------------------------------------------- */
- /* ------------------- STATISTIQUES 1993 -------------------- */
- /* ---------------------------------------------------------- */
-
- /* -- CEE -- */
- insert into tunsql.statistic values(1001,1993, /* -- Allemagne -- */
- 80.55,1846.06,23030,2.2,null,4.1,8.9,39.0,
- 76,1.5,87) ;
- insert into tunsql.statistic values(1002,1993, /* -- Belgique -- */
- 10.04,209.59,20880,2.8,-1.5,2.7,12.1,-1.6,
- 76,1.8,99) ;
- insert into tunsql.statistic values(1003,1993, /* -- Danemark -- */
- 5.17,133.94,25930,1.2,0.5,1.1,12.1,6.5,
- 76,1.7,100) ;
- insert into tunsql.statistic values(1004,1993, /* -- Espagne -- */
- 39.08,547.95,14020,3.8,-3.5,4.8,22.7,-17.0,
- 77,1.3,100) ;
- insert into tunsql.statistic values(1005,1993, /* -- France -- */
- 57.34,1278.65,22300,2.2,-3.6,2.3,11.7,11.6,
- 77,1.8,100) ;
- insert into tunsql.statistic values(1006,1993, /* -- Grande-Bretagne -- */
- 57.70,1024.77,17760,1.5,2.2,3.5,10.3,-19.8,
- 76,1.9,100) ;
- insert into tunsql.statistic values(1007,1993, /* -- Grece -- */
- 10.45,75.11,7180,1.1,-2.3,14.1,10.0,-11.0,
- 78,1.5,null) ;
- insert into tunsql.statistic values(1008,1993, /* -- Irlande -- */
- 3.54,42.80,12100,5.0,6.1,2.2,17.6,5.7,
- 75,2.0,88) ;
- insert into tunsql.statistic values(1009,1993, /* -- Italie -- */
- 57.80,1186.57,20510,2.3,-2.2,4.5,10.2,24.1,
- 78,1.3,null) ;
- insert into tunsql.statistic values(1010,1993, /* -- Luxembourg -- */
- 0.39,13.72,35260,3.1,-1.0,3.5,2.2,null,
- 76,1.8,null) ;
- insert into tunsql.statistic values(1011,1993, /* -- Pays-Bas -- */
- 15.17,312.34,20590,2.1,-2.0,2,8.3,11.3,
- 77,1.7,100) ;
- insert into tunsql.statistic values(1012,1993, /* -- Portugal -- */
- 9.84,73.34,7450,5.5,null,6.3,5.1,-9.1,
- 74,1.4,99) ;
-
- /* ---------------------------------------------------------- */
- /* ------------------- STATISTIQUES 1992 -------------------- */
- /* ---------------------------------------------------------- */
-
- /* -- CEE -- */
- insert into tunsql.statistic values(1001,1992, /* -- Allemagne -- */
- 79.63,1516.78,23650,2.2,null,4.8,7.6,28.9,
- 77,1.5,97) ;
- insert into tunsql.statistic values(1002,1992, /* -- Belgique -- */
- 9.97,192.37,19300,2.1,1.2,2.5,9.3,0.8,
- 76,1.6,99) ;
- insert into tunsql.statistic values(1003,1992, /* -- Danemark -- */
- 5.14,121.70,23660,2.1,1.8,2.1,11,6.8,
- 75,1.5,100) ;
- insert into tunsql.statistic values(1004,1992, /* -- Espagne -- */
- 39.05,486.61,12460,2.9,0.7,6.5,10.8,-34.1,
- 76,1.5,100) ;
- insert into tunsql.statistic values(1005,1992, /* -- France -- */
- 56.68,1167.75,20600,1.8,-0.4,2.9,10.3,3.3,
- 77,1.8,97) ;
- insert into tunsql.statistic values(1006,1992, /* -- Grande-Bretagne -- */
- 57.54,963.70,16750,2.6,-0.9,5.4,10.1,-23,
- 76,1.8,82) ;
- insert into tunsql.statistic values(1007,1992, /* -- Grece -- */
- 10.08,65.5,6230,1.2,-1,15.7,9.1,-11.2,
- 77,1.5,97) ;
- insert into tunsql.statistic values(1008,1992, /* -- Irlande -- */
- 3.5,37.74,10780,2.2,2.7,3.6,17.2,4.8,
- 75,2.1,97) ;
- insert into tunsql.statistic values(1009,1992, /* -- Italie -- */
- 57.72,1072.20,18580,2.1,0,5.4,11,-2,
- 78,1.3,78) ;
- insert into tunsql.statistic values(1010,1992, /* -- Luxembourg -- */
- 0.38,11.76,31080,3.8,1.2,2.8,1.5,null,
- 75,1.5,70) ;
- insert into tunsql.statistic values(1011,1992, /* -- Pays-Bas -- */
- 15.02,278.84,18560,1.5,1.2,3.3,5.6,12.5,
- 77,1.6,100) ;
- insert into tunsql.statistic values(1012,1992, /* -- Portugal -- */
- 10.39,58.54,5620,2.7,0.1,9.2,4.4,-8.8,
- 75,1.6,53) ;
-
- /* ---------------------------------------------------------- */
- /* ------------------- STATISTIQUES 1991 -------------------- */
- /* ---------------------------------------------------------- */
-
- /* -- CEE -- */
- insert into tunsql.statistic values(1001,1991, /* -- Allemagne -- */
- 77.3,1411.34,22730,3.7,3.7,3.4,4.6,20,
- 75,1.5,null) ;
- insert into tunsql.statistic values(1002,1991, /* -- Belgique -- */
- 10.01,154.68,14550,2,0.2,3.3,9.4,1.6,
- 76,1.6,99) ;
- insert into tunsql.statistic values(1003,1991, /* -- Danemark -- */
- 5.13,113.51,22090,-0.3,2.2,2.7,10.3,4.2,
- 75,1.5,100) ;
- insert into tunsql.statistic values(1004,1991, /* -- Espagne -- */
- 39.32,429.4,10920,3.6,0.4,5.9,15.9,-30.3,
- 77,1.6,100) ;
- insert into tunsql.statistic values(1005,1991, /* -- France -- */
- 56.45,1099.79,19480,2.8,0.4,3,9.4,-12,
- 77,1.8,100) ;
- insert into tunsql.statistic values(1006,1991, /* -- Grande-Bretagne -- */
- 57.48,923.95,16070,1.2,-4.4,6.2,8.7,-17,
- 76,1.8,93) ;
- insert into tunsql.statistic values(1007,1991, /* -- Grece -- */
- 10.04,60.24,6000,1.5,-1.6,18.3,8.6,-10.5,
- 77,1.5,98) ;
- insert into tunsql.statistic values(1008,1991, /* -- Irlande -- */
- 3.5,334.67,9550,3.6,3.3,3,15.8,3.7,
- 74,2.2,99) ;
- insert into tunsql.statistic values(1009,1991, /* -- Italie -- */
- 57.58,970.61,16850,2.3,-2.1,6.4,10.9,0,
- 76,1.3,83) ;
- insert into tunsql.statistic values(1010,1991, /* -- Luxembourg -- */
- 0.37,10.87,28770,4.1,0,3.2,1.4,null,
- 75,1.5,null) ;
- insert into tunsql.statistic values(1011,1991, /* -- Pays-Bas -- */
- 14.93,258.8,17390,3,1.7,3.4,6.1,11,
- 77,1.5,100) ;
- insert into tunsql.statistic values(1012,1991, /* -- Portugal -- */
- 10.37,50.69,4890,4.4,3,11.4,3.9,-7.7,
- 75,1.6,91) ;
-
- /* ---------------------------------------------------------- */
- /* ------------------- STATISTIQUES 1990 -------------------- */
- /* ---------------------------------------------------------- */
-
- /* -- CEE -- */
- insert into tunsql.statistic values(1001,1990, /* -- Allemagne -- */
- 78.03,1272.96,20750,3.9,4.7,2.6,5,49,
- 75,1.5,96) ;
- insert into tunsql.statistic values(1002,1990, /* -- Belgique -- */
- 9.89,162.03,16390,4.3,4.2,3.5,8.7,3.3,
- 75,1.6,99) ;
- insert into tunsql.statistic values(1003,1990, /* -- Danemark -- */
- 5.13,105.26,20510,0.7,0.6,2.8,9.6,0.5,
- 75,1.5,100) ;
- insert into tunsql.statistic values(1004,1990, /* -- Espagne -- */
- 39.16,358.35,9150,4.4,2.5,6.8,16.2,-16.8,
- 77,1.6,100) ;
- insert into tunsql.statistic values(1005,1990, /* -- France -- */
- 56.12,1087,17830,3.4,2.5,3.4,8.9,-8,
- 77,1.8,100) ;
- insert into tunsql.statistic values(1006,1990, /* -- Grande-Bretagne -- */
- 57.27,834.17,14570,3.2,0.9,4.6,5.8,-30,
- 76,1.8,93) ;
- insert into tunsql.statistic values(1007,1990, /* -- Grece -- */
- 10.04,53.63,5340,3.1,0.8,20.3,8.3,-3.7,
- 77,1.6,97) ;
- insert into tunsql.statistic values(1008,1990, /* -- Irlande -- */
- 3.54,30.05,8500,2.7,6.2,3.1,14,0.5,
- 74,2.3,99) ;
- insert into tunsql.statistic values(1009,1990, /* -- Italie -- */
- 57.54,871.96,15150,3.5,-0.2,6.3,11.1,-13,
- 77,1.3,null) ;
- insert into tunsql.statistic values(1010,1990, /* -- Luxembourg -- */
- 0.38,9.41,24860,4.1,-1,3.7,1.3,null,
- 75,1.6,null) ;
- insert into tunsql.statistic values(1011,1990, /* -- Pays-Bas -- */
- 14.83,237.41,16010,2.9,4.6,2.4,6.4,9.3,
- 77,1.6,100) ;
- insert into tunsql.statistic values(1012,1990, /* -- Portugal -- */
- 10.33,44.06,4260,4.7,4,13.3,5.1,-1.2,
- 75,1.5,89) ;
-